@echo off

if "%1" == "" goto syntax_error
rem if "%2" == "" goto syntax_error
rem if "%3" == "" goto syntax_error

set TOOL_DBSERVER=%1
set TOOL_DBACCOUNT=qqq
set TOOL_DBPASSWORD=www

@echo Create database Parvis....

call SqlCommand %TOOL_DBSERVER% master %TOOL_DBACCOUNT% %TOOL_DBPASSWORD% createTestDB.sql
if errorlevel 1 goto sql_error

@echo *************************************************************
@echo *
@echo * Database Parvis created successfully.
@echo *
@echo *************************************************************
goto end


:syntax_error
@echo *************************************************************
@echo *
@echo * Syntax error!
@echo * Required parameter is missing.
@echo *
@echo * Usage: CreateTables 'DatabaseServerName' 'Account' 'Password'
@echo *
@echo *************************************************************

:sql_error
:end
